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