UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQ47rMfFP0tWAryHWXsxlUTdLv2sqjL63rJTl7nBRkQ='
WHERE
key_id = '9d99af561b774945fa32373bff7249e339e5d90f978edc3b4272122f9a20deb0'
AND (
token = 'xQ47rMfFP0tWAryHWXsxlUTdLv2sqjL63rJTl7nBRkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)