UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tNh6LBBuXDywnqGO3YDDaSM1a6qy7W64W/dElr8rAXA='
WHERE
key_id = 'a27525e7fb00fc8d745ee6158c13429a0b92623cfc24333816bcb970240d5b1c'
AND (
token = 'tNh6LBBuXDywnqGO3YDDaSM1a6qy7W64W/dElr8rAXA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)