UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'phL/GpRBFQLR2WlzS14Pb23u2tP4S9I/jN7mTkIHNHw='
WHERE
key_id = 'd9f0e080d09f98fc638628ae5989982f71875a2ba799fe9dc11069488898cd42'
AND (
token = 'phL/GpRBFQLR2WlzS14Pb23u2tP4S9I/jN7mTkIHNHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)