UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P8hB3RFSWs0NAFZ02S4jiM7zpeXfZNbvGSHuZzsSgWs='
WHERE
key_id = '4d25c297aaa610f9a5e1bb6ca81ad151c45d46aadb0b02abbd6dbaef35f8ff47'
AND (
token = 'P8hB3RFSWs0NAFZ02S4jiM7zpeXfZNbvGSHuZzsSgWs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)