UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/MjTJXJjuqvrJmODNYWKh0NOq98jrOR0oYZbvZkkVYQ='
WHERE
key_id = 'a19c49f912b95b4a918bbf5953f9103c442c13f648c0c1e26e9d21833f70a92c'
AND (
token = '/MjTJXJjuqvrJmODNYWKh0NOq98jrOR0oYZbvZkkVYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)