UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Zc7Dvrv5pOwdjdVmegoahqCYnhf/YbjiGMKS0fDXRM='
WHERE
key_id = '8047f4dd4c5396d6d011e1f365a1a35f9361468de5a2a4a7cc1a21523e6ed396'
AND (
token = '5Zc7Dvrv5pOwdjdVmegoahqCYnhf/YbjiGMKS0fDXRM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)