UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5pZ96ViEa5wjU7oYLBrH1Ma7CWyuRVq4dD8u7B0r/qg='
WHERE
key_id = '9f2104d64130df4f284135c6c268f8f6364c69e1ec7d27e2e461c87959d2197d'
AND (
token = '5pZ96ViEa5wjU7oYLBrH1Ma7CWyuRVq4dD8u7B0r/qg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)