UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cKiJnP2zgSSid9M+vYDsvLj/9o8BHGZGnuOFIVKp/D8='
WHERE
key_id = 'cdadd889684f81f36f8a4418f5b2b2564aefa0c858d5eddbea5c7206dee3635a'
AND (
token = 'cKiJnP2zgSSid9M+vYDsvLj/9o8BHGZGnuOFIVKp/D8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)