UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0XwcnySSeqa1WAAjGymCsKUTdLFzrIALn7h0cY+9Tvo='
WHERE
key_id = '389abe973336ca7e3a402b44479f353a17c2a84d8d1fec7cfd1d69fff455cb3e'
AND (
token = '0XwcnySSeqa1WAAjGymCsKUTdLFzrIALn7h0cY+9Tvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)