UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ae71eow3r4ll0l7vzPyIkEkClIMbPMxfgBQWiRHo4Q='
WHERE
key_id = '05465a17b1af7c63a73b9fce1b7a8ab64d40d4073ea27c178ccf5b45f023e7e9'
AND (
token = '1ae71eow3r4ll0l7vzPyIkEkClIMbPMxfgBQWiRHo4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)