UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OP1DvvMV36UszWhu1a5gBBZRutDkiZtWRdKO4V6lqyw='
WHERE
key_id = 'a346c1b77f7f6d0ec0c0ea72fd69efcc0f6aaf75dda7deec2d01ab37988afd96'
AND (
token = 'OP1DvvMV36UszWhu1a5gBBZRutDkiZtWRdKO4V6lqyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)