UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'apNzdJ07shVtIsykjzpcq6e8Rx71NLWaoILGr5BILJw='
WHERE
key_id = '3d3e24ad647be5d5d0bbc778bcb8eb7200a4f354682664fde49d59ccc5103717'
AND (
token = 'apNzdJ07shVtIsykjzpcq6e8Rx71NLWaoILGr5BILJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)