UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XD9Pw4E6NcEX9+Sf3MwEf45dVXvQ6iDHfICBV7p3RQ='
WHERE
key_id = '100f74bff74e26244dcbbc78957e71ab256756a15b5977f6dd7cf5b9030e550e'
AND (
token = '6XD9Pw4E6NcEX9+Sf3MwEf45dVXvQ6iDHfICBV7p3RQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)