UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zzks7CF84i0xhvSdW0O5VGhT5FiuacmkyC0GlVI4Ddo='
WHERE
key_id = '80c7c9a3d6473665a223a0f41707ad406e4469a92ed44dddeb8a0def01e2e075'
AND (
token = 'zzks7CF84i0xhvSdW0O5VGhT5FiuacmkyC0GlVI4Ddo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)