UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mzn7CcEel52S7AR9hb+L/840C9byfe/rXoLognhaJyY='
WHERE
key_id = 'be6d81e3551cd692a46abb498ad232be63133d14617f700346d6b5667ef796a5'
AND (
token = 'mzn7CcEel52S7AR9hb+L/840C9byfe/rXoLognhaJyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)