UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UWKrrLEhrDlyz4TNEgUUWQIr3OSzCR/AzE6PmUuqZgk='
WHERE
key_id = 'bb2f8ac65662f545efbcd4df682e28caaa0899192e046cb36e0d92dfa579533b'
AND (
token = 'UWKrrLEhrDlyz4TNEgUUWQIr3OSzCR/AzE6PmUuqZgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)