UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WsAmNgYnLXmk5j14ZSwNC5S1biLalV5kkAJq9XcRe0o='
WHERE
key_id = 'b1199eb506c6311fc9a8e35183a7c0bee0173ffcdd30b8bcd44ebc434e04e7bf'
AND (
token = 'WsAmNgYnLXmk5j14ZSwNC5S1biLalV5kkAJq9XcRe0o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)