UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGbnaEl2IKolLJYvM5mCjXDm90FxUCe7Ec0Cc+m1b6E='
WHERE
key_id = 'c0ade5f6a124b4488b93193b4168176ef6055ed9c81de6a287653cb86eb8541d'
AND (
token = 'pGbnaEl2IKolLJYvM5mCjXDm90FxUCe7Ec0Cc+m1b6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)