UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O5a3gYjaSVKiDRthajplAu0QKg0AtAXC4mH8hYhM1rw='
WHERE
key_id = 'a3e5f7a145b647fc9b15c1ba65d03a9affc145e5bcbe2dcd9f0ed982f81d932e'
AND (
token = 'O5a3gYjaSVKiDRthajplAu0QKg0AtAXC4mH8hYhM1rw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)