UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0GVUFA0W0K62st7eDh5eM8hyv9CrnLHDTGNwkZ9KTeY='
WHERE
key_id = '1f1fbe38a6a2e3525390a311bdc05d944dabb5a3e1a1ecab822785939ab049be'
AND (
token = '0GVUFA0W0K62st7eDh5eM8hyv9CrnLHDTGNwkZ9KTeY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)