UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zj5EPde3DFPRUAD4XIVfNtcCNgVtVFhF5S4OUSGpIII='
WHERE
key_id = '6a6d660caf9209cb34e07895d68b579ea0f302c8f682a5cea96ef5dabb231d95'
AND (
token = 'zj5EPde3DFPRUAD4XIVfNtcCNgVtVFhF5S4OUSGpIII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)