UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qjGIXle0O6Uj1tZUtGs+vDfLQXAtSRB49t31Xg4CE1w='
WHERE
key_id = 'c4ee9a35bdce9a1c85df8a9f173b68ef03df23e191d399638697e3f113dc9b6f'
AND (
token = 'qjGIXle0O6Uj1tZUtGs+vDfLQXAtSRB49t31Xg4CE1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)