UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xp68AXimpb1aA4IxyHKNxTm8XlSWgEsCzdF2ya2QyyE='
WHERE
key_id = 'b8fb5996ad635d66c8d3ed85cfbecc69a19a19dab29529bcf78a6473a0c6dd5c'
AND (
token = 'Xp68AXimpb1aA4IxyHKNxTm8XlSWgEsCzdF2ya2QyyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)