UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nszQnKq5n7JVDiJCbW6lf2hx7nf9yX8JccddV6kEVMc='
WHERE
key_id = '300296eb99531d74968f61bdd2f3c97df2c91a4af93a2bbeab5ac4cd75c7e68e'
AND (
token = 'nszQnKq5n7JVDiJCbW6lf2hx7nf9yX8JccddV6kEVMc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)