UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BIksaggUra7w6+/yezZbH1AbQx1Wmay7Jr45Cuj50Jo='
WHERE
key_id = '8783a1b03e57c8feeb4a764705e50486821c642ac4fcc9c4294a1bfc1f24b30b'
AND (
token = 'BIksaggUra7w6+/yezZbH1AbQx1Wmay7Jr45Cuj50Jo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)