UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iS3638B8R8KtYIvUgG/NHec6ILZkb72OdrSt35LyQSU='
WHERE
key_id = '8e1818c78b4b08071d78b0d104cf36805af66c8922166c9e319b5723cd7f3bf0'
AND (
token = 'iS3638B8R8KtYIvUgG/NHec6ILZkb72OdrSt35LyQSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)