UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6DLEgsN3wFqwFflen7mn6/z4dBtWGNDTlklA0EJk7M='
WHERE
key_id = '7f8883808a5e13f0ac5dc8d807a6876b0d03529486687d38fe6ede5c793b7354'
AND (
token = 'C6DLEgsN3wFqwFflen7mn6/z4dBtWGNDTlklA0EJk7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)