UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9g8sbafVtVJXn3UHEUxA2YA1BDbCD3GHdGm5yWTy7IA='
WHERE
key_id = '7a0dd190a39a3a84462e492fab9072c838be299325f0da9b37810f3052edd88c'
AND (
token = '9g8sbafVtVJXn3UHEUxA2YA1BDbCD3GHdGm5yWTy7IA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)