UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cw7hBRtp0avEKmVuE/FsxKhWDsMG6jghX6MXKaRQcwc='
WHERE
key_id = '24842f3e92972247a712388db761c553dc2ec48ff3f7267600da5fdd29b6fa5a'
AND (
token = 'cw7hBRtp0avEKmVuE/FsxKhWDsMG6jghX6MXKaRQcwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)