UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bPqM6+4qRb7IMrXHNdiIYdIj6kNKmsIYxl3Z/H8bcIY='
WHERE
key_id = 'fbf3323cc2f5dcc5f431ad4d6f4e8a90b9f710daaacda46b5852e9b59a0b1c10'
AND (
token = 'bPqM6+4qRb7IMrXHNdiIYdIj6kNKmsIYxl3Z/H8bcIY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)