UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vEjoMZDEgn2YB9j5/WxbMLxlrAhaplf1tuZVWi4fM6Y='
WHERE
key_id = '12b93313b90443645bb696e7f03733fe99a20ce603132a0344c8f74b6ff70b80'
AND (
token = 'vEjoMZDEgn2YB9j5/WxbMLxlrAhaplf1tuZVWi4fM6Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)