UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XnDSiDLCGnD9DTVjDWy6cvmE4DDoWG017dWb++CTMCg='
WHERE
key_id = 'efbbe4177a6002b179070b55739251da90eb9ff149286d4876a0b2de1ccd0137'
AND (
token = 'XnDSiDLCGnD9DTVjDWy6cvmE4DDoWG017dWb++CTMCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)